datetime

[vjcaldeira1]

HI!! I

need save a field that have date , hour ,minutes and seconds. when a put this cod Text(Now();"[$-pt-BR]yyy-mm-dd hh:mm:ss")) be with error because is a text and  my field is date time.
when I put this DateTimeValue(Text(Now();"[$-pt-BR]yyy-mm-dd hh:mm:ss"))), be without seconds.

Someone Can I help me ??

thanks a lot

[RandyHayes]

@vjcaldeira1 

Date values have no format.  Format is dependent on your locale when displaying a date.  But they are always saves in a numeric data value format (that you should not concern yourself with).

So, point being...if you want to store the current date and time, then simply use the Now() function.

Then when you go to display that value, then you can use the Text functions to display in the way that you want.

I hope this is helpful for you.

[v-yutliu-msft · Accepted solution]

Hi @vjcaldeira1 ,

Do you want to update to datetime type field with this format "yyy-mm-dd hh:mm:ss"?

Actually, this is the setting of your data source.

Could you tell me what is your data source?

If it is sharepoint list, I'm afraid it's not supported to display date time with this format "yyy-mm-dd hh:mm:ss".

In sharepoint list, date time value could only include year,month,date,hour and minute.

If you insist in updating with second value, I suggest you do not use date time value, changing to text type field.

You could text type field with whatever time format that you want.

Use formula like this to update:

Text(Now();"[$-pt-BR]yyy-mm-dd hh:mm:ss")

Best regards,