Date Format of datetime control in dynaform

Forum rules: Please search to see if a question has already been asked before posting. Please don't ask the same question in multiple forums.

2 posts
First unread post

2 posts

Date Format of datetime control in dynaform#786266

By Anuradha - Mon Aug 08, 2016 6:02 am

- Mon Aug 08, 2016 6:02 am #786266

Hello All,
I have one dynaform which contain date in format YYYY-MM-DD but the value save in report table is like 2000-10-10 00:00:00.
we want to save it in format of YYYY-MM-DD because it will be further use in output document to show its value. Please provide any solution for this.

Thanks in advance.

Re: Date Format of datetime control in dynaform#786666

By michaeltimoteo - Mon Sep 19, 2016 10:04 pm

- Mon Sep 19, 2016 10:04 pm #786666

Hello Anuradha,

In the report table use the date variable that has a prefix of _label.

For example: You created a variable @@Birthday, in the report table it will create a @@Birthday and @@Birthday_label. @@Birthday will produce a timestamp with YYYY-MM-DD Hour:Minute:Sec format but @@Birthday_label will produce a date with YYYY-MM-DD.