|
| How do you get the DateTime ? |
| Iniciado por joel.waldron, 18,sep. 2008 01:51 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 18,septiembre 2008 - 01:51 |
On each record I create, I have a field called "Created". In the analysis it is set up as a "Date Type" and a sub-type of "Date and Time". I'm trying to get the "Date and Time" in there, but can't figure out how. There is no DateTime() Function. My code is as follows:
PROCEDURE Pr_UpdateCreatedOrModified()
SWITCH H.TriggerFunction
CASE "HAdd"
{H.FileName+".Created"} = Today()
{H.FileName+".Modified"} = Today()
CASE "HModify"
{H.FileName+".Modified"} = Today()
END
I know the Today() function is wrong (and it is storing nothing in the field) but I can't figure out what to use.
Thank you! |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,septiembre 2008 - 00:35 |
Hi Joel,
Try
{H.FileName+".Created"} = DateSys() + TimeSys()
Christian
Joel a écrit dans le message de news <bc7eea88014efb2342dbc8d94446abf3@news.pcsoft> :
On each record I create, I have a field called "Created". In the analysis it is set up as a "Date Type" and a sub-type of "Date and Time". I'm trying to get the "Date and Time" in there, but can't figure out how. There is no DateTime() Function. My code is as follows:
PROCEDURE Pr_UpdateCreatedOrModified()
SWITCH H.TriggerFunction
CASE "HAdd"
{H.FileName+".Created"} = Today()
{H.FileName+".Modified"} = Today()
CASE "HModify"
{H.FileName+".Modified"} = Today()
END
I know the Today() function is wrong (and it is storing nothing in the field) but I can't figure out what to use.
Thank you! |
| |
| |
| | | |
|
| | | | |
| | |
|